Select Lesser Values Of An N Record From Every Distinct Value Of X

Use this option to filter records that have a lower value.

For example, a Mail shot campaign to the customer in each household who has the lowest Customer Profit Decile.

Procedure

1. On N per X, select One per Household ID from the Household or Customer table depending on requirement - See N per X & grid seg campaigns.htm
2. Select a value in the Using field, for example 'Income'.
3. Select Lesser Values.
4. Select the Allow 0's and NULLS to be selected check box.

This ensures that customers with a zero or Null income will be included in the selection.

If there is only one customer in the household, that customer will be selected.